package com.erp.app.common.query;

import com.erp.app.catalog.itemLine.pk.ItemLinePk;

public class ProductCatalogQuery extends BeanQuery {

	public String companyCode;

	public String itemLine;

	public ProductCatalogQuery() {
		super(
				"SELECT NODE_ID,DESCRIPTION  FROM T_CATALOG WHERE "
						+ "COMPANY_CODE = `companyCode:string` AND "
						+ "CATALOG_LEVEL=1 AND "
						+ "NODE_ID = `itemLine:string` AND"
						+ "(STATUS = `$GENERIC_ACTIVE:string`) ORDER BY NODE_ID");
		this.setModel(this);
	}

	public String getCompanyCode() {
        return companyCode;
    }

    public ProductCatalogQuery setCompanyCode(String companyCode) {
        this.companyCode = companyCode;
        return this;
    }


    public ProductCatalogQuery setItemLine(String itemLine) {
        this.itemLine = itemLine;
        return this;
    }

	public ProductCatalogQuery setCatalogPk(ItemLinePk pk) {
		this.setCompanyCode(pk.getCompanyCode());
		this.setItemLine(pk.getItemLine());
		return this;
	}


	public String getItemLine() {
		return itemLine;
	}

}
